Name |
|
Code |
|
Comment |
PL: tabela przechowuje informacje o zaczytanych kodach QR z opakowan |
Name |
Code |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(64) |
Mandatory |
Yes |
Comment |
zeskanowany kod seryjny |
Name |
|
Code |
|
Data Type |
VARCHAR2(16) |
Mandatory |
No |
Comment |
kod gtin |
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
kod seryjny |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
data waznosci |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
data weryfikacji w systemie nmvs |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
data wycofania w systemie nmvs |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
numer pozycji |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
Yes |
Comment |
aktywnosc rekordu |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
stan leku w bazie nmvs opis |
Name |
|
Code |
|
Data Type |
VARCHAR2(20) |
Mandatory |
No |
Comment |
stan leku w bazie nmvs kod |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Id statusu serii leku z systemu nmvs |
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|